Accounts Receivable Posting Scan Report

The Accounts Receivable (A/R) Posting Scan Report shows the posting date, post department and type, amount, and other information relevant to any A/R postings. This report allows you to select the type (adjustments, corrections, transfers), building, operator, and specific postings and filter only the postings that are Accounts Receivable Postings (to an A/R #).

Note: If you do not select any options within the building, operator, post type, or department, the report shows all postings within those categories.  

The A/R Posting Scan Report command is found in the Accounting Menu, which may be reached using the Files Menu.

Note: You can also generate a Condo Posting Scan Report , a POS Posting Scan Report or a Hotel Posting Scan Report from this screen, using the check boxes at the top of the screen. By default, if you entered this screen using the A/R Posting Scan Report command, the A/R Postings check box will be selected.

 

 

 

Quick MenuFiles Menu

 

 

click Files => from the Other section of the Full Menu.

 

 

Click the icon on the left, or the breadcrumb words "Full Menu" on the top right of the screen to open the Full menu.

Full Menu Icon OR Full Menu option when viewed using the modern light look of Skyware

This will display the Full menu in a tabular form, with four sections, Registration, Status, Cashier and Other.

Full Menu Table OR Full Menu popup version seen in Modern Light look of Skyware

Select Files => from the Other section.

Other section of Full Menu with Files => command selected OR Other Section of the Full Menu with Files => command selected, NEW look for Skyware

The Files Menu is divided into two sections, Files List 1 and Files List 2.

Files Menu screen OR Files Menu example, NEW look for Skyware

Select the Accounting => command from the Files List 2 section.

Files List 2 section of the Files Menu with Accounting => command selected OR Files List 2 section of the Files Menu with Accounting => command selected, NEW look for Skyware

 

The Accounting Menu is divided into two sections, General and Reports.

Accounting Menu screen OR Accounting Menu, NEW look for Skyware

Select the A/R Postings Scan Report command from the Reports section:

Reports section of the Accounting Menu with A/R Postings Scan Report command selected OR Reports section of the Accounting menu with A/R Postings Scan Report command selected, NEW look for Skyware

 

When selected, the Postings Scan Report Screen will open, with the A/R Postings option already checked.

A/R Posting Scan Report screen example

Note: The Postings Scan Report screen has options for reporting on Hotel postings, A/R postings, POS postings and Condo postings. You can therefore also generate a Hotel Posting Scan Report, a Condo Posting Scan Report , or a POS Postings Scan Report from this screen by selecting the specific option instead of the A/R postings option. By reaching the screen using the A/R Postings Scan Report command, the check box for A/R postings will be selected automatically for you.

Postings Scan Report screen with Posting type A/R selected and highlighted

Postings Type: By default the box for A/R postings will be checked. Selecting any other postings option will automatically un-check the A/R option - only one can be selected at a time.

 

 

Select the appropriate reporting options for the Report. There are multiple options allowing you to tailor the report to your needs.

Report options for Postings Scan Report screen

Report Type: Select a Report Type option from the radial buttons available. Only ONE option may be selected. Choose All for all postings, Corrections for only corrected postings, Adjustments for only adjusted postings, Transfers for only postings transferred to another folio, or Tax Exempt for postings that are tax exempt. By default it is set on All.

Select Date Range: Select a Date Range for the report. Clicking in the date field will show a calendar icon allowing you to choose both the start and end dates for the report. By default it is set to today's date (one day of reporting).

Sort by: Select the Sort Order from the radial buttons available to determine how the postings listed in the report are sorted. Only ONE option may be selected. Choose Posting Type, Date or Room #. By default it is set to Posting Type.

Report Status: The report may show all postings, or just active postings. Choose one. By default, All is selected.

Group by:  This determines the order of data displayed in the report. Choose from All or User. By default it is set to All.

Summary by Posting Type: This checkbox may be checked if you wish to show a SUMMARY (total) for each of the POS posting types, rather than the individual postings on the report. This can help to reduce the size of the report. By default it is unchecked.

Amount Range: If you wish to limit the report to showing the POS postings that were for certain amounts only, you can enter the from and to amounts into the two fields here. If used, only postings that fall within the amount range will be shown. This can help to reduce the size of the report. By default the fields are left blank, meaning all postings (for any amount) will be shown.

Show UnRealized Revenue (Room and Tax, Recurring Charges for the Current Day): This checkbox option allows you to see any revenue not yet posted that will be for the day during night audit. Select this check box to show expected room, tax, and recurring charges that are due but have not been posted for the date range identified for the report. By default it is unchecked. Note: It is not usually relevant to the POS Postings Scan Report.

Use Server assigned to Check: This checkbox may be checked to show postings by each Server when a different user is acting as Cashier. By default it is unchecked.

Suppress Zero (0) Postings: This checkbox may be checked to suppress any postings that are for 0.00 from showing on the report. This can help to reduce the size of the report. By default it is unchecked. Note: This option is primarily useful for the POS Postings Scan Report.

Complete the fields described below: Select the appropriate reporting options for the Report.

 

 

The report may be filtered further, by selecting the options you wish to see shown on the report from the Building, Operators, Departments and Posting Types categories listed.

filter options for Postings Scan Report screen example

Note: Selecting specific Departments to show on the report will change the options available in the Posting Types list (to show only those available within the selected department(s) ).

Filter options for Postings Scan Report generation where a department has been selected, limiting the posting type options available

Use the check boxes in the Select Buildings, Select Operators, Select Departments, and Posting Types lists to filter the report to show only those options selected. This can help to reduce the size of the report and show only what you are interested in.

Note: For the Building, Operators and Departments categories, selecting a checkbox will AUTOMATICALLY update the screen. For Posting Types (due to the probability that multiple will be selected), you will need to click the button marked "Press" above the section once you have marked all the relevant Posting Types to update the report screen with your selections.

Filter option section detail with the Press button highlighted

 

Note: No Selections = No Filter.

 

When you are finished with the report options and filter settings, click the Show Results button at the top of the screen to generate the report.

A/R postings scan report screen example with show results button and generate reports section highlighted

By default, the report is generated in PDF form and opens in a separate browser window. From there you can select to save or print the report, among other options. If you prefer, you can select the Generate report to Excel or Generate report to Excel (data only) check box to print the report in Microsoft Excel format instead of PDF. The information in this case will be correct for importing into another document rather than immediate viewing.

 

This will generate the A/R Postings Scan Report (A/R Transaction Report).

A/R transaction report example

Once generated, the report shows, for each A/R posting type, the posting date, post department and type, room number, amount, guest name, any reference, the A/R account # associated with the posting, any transaction ID, the relevant stay ID, and the User ID, with a total section for each posting type and a grand total of all revenue.

Note: IF the Summary by Posting Type option was selected, the report does not show the breakdown details of the posting types, instead showing simply the revenue totals for each posting type and the grand total.

A/R transaction report summary example

NOTE: The generated report appears as a pop-up window through your browser. If your browser is set to block pop-ups, you may receive a warning banner at the top of the browser. Click this banner and select to allow pop-ups so that you can view the report.

 

Date Updated August 03, 2023